[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '20' >
8 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 223 | 12.45 | 1981-06-30 | Production | charles0@adventure-works.com | Charles Fitzgerald | 931-555-0118 | 537092325 | Charles | M | 2019-10-01 | Fitzgerald | adventure-works\charles0 | S | B | 20 | 1 | 931-555-0118 | | 33 | 2019-10-01 | Current | Production Technician - WC60 | 27 |
| 55 | 12.45 | 1994-10-27 | Production | david2@adventure-works.com | David Ortiz | 712-555-0119 | 36151748 | David | M | 2018-10-13 | Ortiz | adventure-works\david2 | M | J | 20 | 1 | 712-555-0119 | | 36 | 2018-10-13 | Current | Production Technician - WC60 | 33 |
| 230 | 12.45 | 1980-01-03 | Production | karan0@adventure-works.com | Karan Khanna | 447-555-0186 | 834186596 | Karan | M | 2019-10-20 | Khanna | adventure-works\karan0 | S | R | 20 | 1 | 447-555-0186 | | 34 | 2019-10-20 | Current | Production Technician - WC60 | 28 |
| 247 | 12.45 | 1964-11-27 | Production | maciej0@adventure-works.com | Maciej Dusza | 237-555-0128 | 414476027 | Maciej | M | 2019-11-27 | Dusza | adventure-works\maciej0 | S | W | 20 | 1 | 237-555-0128 | | 35 | 2019-11-27 | Current | Production Technician - WC60 | 30 |
| 258 | 12.45 | 1983-07-04 | Production | michael7@adventure-works.com | Michael Zwilling | 582-555-0148 | 582347317 | Michael | M | 2019-12-22 | Zwilling | adventure-works\michael7 | S | J | 20 | 1 | 582-555-0148 | | 33 | 2019-12-22 | Current | Production Technician - WC60 | 26 |
| 259 | 12.45 | 1980-02-24 | Production | randy0@adventure-works.com | Randy Reeves | 961-555-0122 | 8066363 | Randy | M | 2019-12-22 | Reeves | adventure-works\randy0 | M | T | 20 | 1 | 961-555-0122 | | 34 | 2019-12-22 | Current | Production Technician - WC60 | 29 |
| 178 | 12.45 | 2001-02-01 | Production | steve0@adventure-works.com | Steve Masters | 712-555-0170 | 752513276 | Steve | M | 2018-12-14 | Masters | adventure-works\steve0 | S | F | 20 | 1 | 712-555-0170 | | 35 | 2018-12-14 | Current | Production Technician - WC60 | 31 |
| 212 | 12.45 | 1985-12-09 | Production | jay0@adventure-works.com | Jay Adams | 407-555-0165 | 63179277 | Jay | M | 2019-01-01 | Adams | adventure-works\jay0 | S | G | 20 | 1 | 407-555-0165 | | 36 | 2019-01-01 | Current | Production Technician - WC60 | 32 |
Generated 2024-04-27 15:54:37.703 UTC